package com.rs.statistics.dao;

import javax.transaction.Transactional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import com.rs.statistics.model.Member;
@Transactional
public interface IMemberDao extends JpaRepository<Member, Integer>,JpaSpecificationExecutor<Member>{
/**
 * 
 * @param id
 * @param status 资源状态
 * @return
 */
	@Modifying
	 @Query("update Member m set m.status=:status where m.id =:id")
	int findByIdAndStatus(int id, int status);

	

}
